Excel VBA űrlap kialakítása egymintás t-próba kiértékeléséhez
نویسندگان
چکیده
A Microsoft Excel program Visual Basic for Applications szolgáltatásával kialakítottunk egy felhasználóbarát felületet egymintás t-próba elvégzésére. Így akár az táblázatkezelő használatának ismerete nélkül is lehetőség van egyik leggyakrabban megjelenő hipotézisvizsgálat, a használathoz elegendő megnyitni elkészített alkalmazást, s ablakban szükséges adatok és opciók beállítása után megkapjuk eredményeket. vezérlőkkel biztosítja könnyű kezelhetőséget, míg működést eseményvezérelt programozási technikával alakítottuk ki. Az eredményeket megkaphatjuk betáplált minta adatsor alapján is, de főbb jellemzői, elemszám, átlag szórás értékéből is. vizsgálandó hipotézis megadásakor tetszőleges reláció alkalmazható, ettől függően kétszélű vagy egyszélű eset egyikeként, automatikusan kapjuk meg alkalmazás használatával matematikai statisztikai ismeretek programcsomag végezhetjük el t-próbát.
منابع مشابه
Programming Excel with VBA and .NET - solve real-world problems with Excel
by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...
متن کاملAssessing Excel VBA Suitability for Monte Carlo Simulation
Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...
متن کاملToward Reverse Engineering of VBA Based Excel Spreadsheet Applications
Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by practitioners that do not follow any software engineering practice and do not produce any design documentation. Thus, spreadsheet applications may be very difficult t...
متن کاملSpPack: spatial point pattern analysis in Excel using Visual Basic for Applications (VBA)
Many different sciences have developed many different tests to describe and characterise spatial point data. For example, all the trees in a given area may be mapped such that their x, y co-ordinates and other variables, or ‘marks’, (e.g. species, size) might be recorded. Statistical techniques can be used to explore interactions between events at different length scales and interactions betwee...
متن کاملCalculation of a distribution free estimate of effect size and confidence intervals using VBA/Excel
Reporting effect sizes aids the transparent presentation and independent interpretation of scientific data. However, calculation and reporting of effect sizes for data obtained in basic research is rare. A standardized effect size was reported by Norman Cliff, known as Cliff's delta. It has several advantageous features, as (i) it makes no assumption on the shape of the underlying distribution,...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Jelenkori társadalmi és gazdasági folyamatok
سال: 2021
ISSN: ['1788-7593', '2676-9867']
DOI: https://doi.org/10.14232/jtgf.2021.3-4.65-75